create database wpsj_musicbox
go
use wpsj_musicbox
go

create table account
(
userID int primary key identity not null,
loginName nvarchar(100),
password nvarchar(100),
fullName nvarchar(200),
phone int,
email nvarchar(100)
)

create table album
(
albumID int primary key identity,
albumName nvarchar(100),
author nvarchar(100),
released datetime
)

create table song
(
songID int primary key identity,
songName nvarchar(100),
singer nvarchar(100),
album nvarchar(100),
released datetime,
uploadBy nvarchar(100)
)

create table singer
(
singerID int primary key identity,
singerName nvarchar(100),
age int,
address nvarchar(200)
)